SELECT    COUNT(*) 'employee from London'
FROM    [Northwind].[dbo].[Employees] 
WHERE City='London'